package common

//define table and define database name

const (
	DBInformationSchema = "information_schema"
	DBChess             = "chess"
	DBChessCenter       = "chess_center"
	DBChessPartner      = "chess_partner"
	DBChessLog          = "chess_log"
	DBChessLog2         = "chess_log2"
	DBChessSysData      = "chess_sysdata"
)

const (
	/*----------------------pc----------------------*/
	TablePcUser  = "pc_user"  //pc端管理用户表
	TablePcRole  = "pc_role"  //角色
	TablePcMenu  = "pc_menu"  //菜单
	TablePcGroup = "pc_group" //大区区域
	/*----------------------chess_center----------------------*/
	TableH5User           = "h5_user"            //代理表
	TableH5AuthCode       = "h5_auth_code"       //授权码
	TableH5CardRecord     = "h5_card_record"     //钻石变动记录
	TableH5CashRecord     = "h5_cash_record"     //收入变动记录
	TableH5AgentPlayer    = "h5_agent_player"    //在此代理充值过的玩家
	TableH5CardCash       = "h5_card_cash"       //代理的钻石及收入
	TableH5AgentBank      = "h5_agent_bank"      //代理银行卡信息
	TableH5Order          = "h5_order"           //代理或玩家订单列表
	TableH5WithdrawRecord = "h5_withdraw_record" //代理提现记录
	TableH5Feedback       = "h5_feedback"        //代理反馈记录
	TableH5FeedbackUrl    = "h5_feedback_url"    //代理反馈记录图片
	TableSystemUser       = "system_user"        //系统帐号

	TableGroupGame = "group_game" //大区游戏
	/*----------------------chess_partner------------------*/
	TablePfUser           = "partner_user"            //代理表
	TablePfCardRecord     = "partner_card_record"     //钻石变动记录
	TablePfCashRecord     = "partner_cash_record"     //收入变动记录
	TablePfAgentPlayer    = "partner_agent_player"    //在此代理充值过的玩家
	TablePfCardCash       = "partner_card_cash"       //代理的钻石及收入
	TablePfAgentBank      = "partner_agent_bank"      //代理银行卡信息
	TablePfOrder          = "partner_order"           //代理订单列表
	TablePfWithdrawRecord = "partner_withdraw_record" //代理提现记录
	TablePfFeedback       = "partner_feedback"        //代理反馈记录
	TablePfFeedbackUrl    = "partner_feedback_url"    //代理反馈记录图片

	TablePfLoginLog = "partner_login_log" //代理的登录日志

	TablePbUser       = "pb_user"        //后台系统用户表
	TablePbCashRecord = "pb_cash_record" //收入变动记录

	TablePcCashRecord = "pc_cash_record" //公司的提成收入记录(合伙人系统)

	/*----------------------client------------------*/
	TableClientUser     = "user"      //玩家用户表
	TableClientUserAttr = "user_attr" //玩家属性表

	TableClientPassport = "passport"     //玩家通行证
	TableAgentPlayer    = "agent_player" //玩家与渠道的关系

	TableLotteryProduct       = "lottery_product"        //抽奖奖品列表
	TableLotteryRecord        = "lottery_record"         //玩家抽奖记录
	TableLotteryConsumeRecord = "lottery_consume_record" //玩家用钻石购买抽奖次数的记录
	TableLotteryUser          = "lottery_user"           //玩家的奖品
	TableLotteryExchange      = "lottery_exchange"       //钻石兑换抽奖次数表

	/*----------------------chess_log------------------*/
	TableDayGame      = "daygame"
	TableDayTrans     = "daytrans"       //金流
	TableDayTransStat = "day_trans_stat" //金流统计
	TableEventLog     = "event_log"      //事件日志
	TableDayClub      = "day_club"       //亲友圈数据统计表

	TableDayAgent         = "day_agent"          //日报表:一级代理和二级代理自身的买卖钻石情况,及可提现金额,代理增长数量
	TableDayAgentLevel1   = "day_agent_level1"   //日报表:一级代理及名下所有二级代理之和的买卖钻石情况,及可提现金额,代理增长数量
	TableMonthAgent       = "month_agent"        //月报表:一级代理和二级代理自身的买卖钻石情况,及可提现金额,代理增长数量
	TableMonthAgentLevel1 = "month_agent_level1" //月报表:一级代理及名下所有二级代理之和的买卖钻石情况,及可提现金额,代理增长数量
	TableDayGroup         = "day_group"          //日报表:大区的买卖钻石情况,及可提现金额,代理增长数量
	TableMonthGroup       = "month_group"        //月报表:大区的买卖钻石情况,及可提现金额,代理增长数量

	TableClientError          = "client_error"           //游戏客户端上报的错误日志
	TableClientOperationError = "client_operation_error" //游戏客户端手动上报的错误日志
	TableRecordDay            = "record_day"             //统计记录时间,统计到哪一天了
	TableDayPlayerInfo        = "day_player_info"        //统计用户一些数据,如用户留存率,日活，日注册
	TablePlayerLoginLog       = "player_login_log"       //玩家的登录日志
	TableAgentLoginLog        = "agent_login_log"        //代理的登录日志
	TableOperationLog         = "operation_log"          //pc端操作日志
	TableSystemUserTran       = "system_user_tran"       //系统帐号流水记录
	TableDaySystemUser        = "day_system_user"        //系统帐号流水报表,日报表
	TableMonthSystemUser      = "month_system_user"      //系统帐号流水报表,月报表
	TableDayGameStat          = "day_game_stat"          //统计每天每款游戏开的桌子数及小局数,日活

	/*----------------------chess_log2-------------------*/
	TableSubmitLog = "submit_log" //游戏客户端上报的错误日志

	/*----------------------chess-------------------*/
	TableRegisterCount = "register_count" // 每隔半小时的注册用户数统计
	TableOnlineCount   = "onlinecount"    // 在线统计
	TableOnlineDetail  = "onlinedetail"   // 在线
	TableNetDelay      = "netdelay"       //玩家网络延迟方面的

	TableRoom      = "proom"     // 开房信息
	TableRoomLog   = "proomlog"  // 加入房间记录
	TableEmailUser = "emailuser" // 邮件
	TableEmailFull = "emailfull" // 全服邮件

	TableClub        = "club"                // 亲友圈
	TableClubScore   = "club_score"          // 俱乐部上下分
	TableClubFloor   = "club_floor"          //亲友圈里的楼层
	TableClubMember  = "club_member"         // 亲友圈成员表
	TableIdFactory   = "id_factory"          //亲友圈号用户号等
	TableFeedback    = "client_feedback"     //游戏玩家反馈记录
	TableFeedbackUrl = "client_feedback_url" //游戏玩家反馈记录图片
	TableAppOrder    = "app_order"           //商城商品订单
	TablePhoneLog    = "phone_log"           //绑定过手机的记录
	TableWhiteList   = "white_list"          //上下分白名单
	TableUserGame    = "user_game"           //玩家玩游戏玩了多少局的情况

	/*------------------sysdata---------------------*/
	TableRoomCardCfg    = "roomcardcfg"     // 钻石消耗配置
	TableStore          = "store"           //商城商品
	TableDiamondCoin    = "diamond_coin"    //钻石对金币的兑换表
	TableH5CardPrice    = "h5_card_price"   //钻石价格列表
	TableH5TopUp        = "h5_top_up"       //代理开通第一次充值
	TableH5Rule         = "h5_rule"         //代理规则表
	TableServerInfo     = "serverinfo"      // 服务器信息
	TablePlatform       = "platform"        // 平台服务器信息
	TableGameList       = "game_list"       //游戏列表
	TableAreaGameList   = "area_game_list"  //区域游戏列表
	TableActivityNotice = "activity_notice" //游戏活动公告及系统公告
	TableGameNotice     = "game_notice"     //子游戏大厅里游戏活动公告
	TableAgentNotice    = "agent_notice"    //子游戏大厅里游戏招募代理公告
	TableH5Notice       = "h5_notice"       //h5公告
	TableOtherConf      = "other_conf"      //其它一些零散的配置
	TableHorse          = "horse"           //游戏客户端及代理助手的跑马灯
	TableCardTest       = "card_test_cfg"   //配牌方面的，测试专用
	TableSystemConf     = "sysconfig"       //系统配置
	TableAppVersion     = "app_version"     //app版本记录
	TablePayType        = "pay_type"        //支付方式，支付比例
	/*------------------information_schema-----------*/
	TableTables = "TABLES"
)
